Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 105000 |
| Missing cells | 8563 |
| Missing cells (%) | 0.5% |
| Duplicate rows | 790 |
| Duplicate rows (%) | 0.8% |
| Total size in memory | 14.4 MiB |
| Average record size in memory | 144.0 B |
Variable types
| Numeric | 16 |
|---|---|
| Categorical | 2 |
rerun has constant value "301.0" | Constant |
| Dataset has 790 (0.8%) duplicate rows | Duplicates |
objid is highly correlated with run | High correlation |
u is highly correlated with g and 3 other fields | High correlation |
g is highly correlated with u and 3 other fields | High correlation |
r is highly correlated with u and 3 other fields | High correlation |
i is highly correlated with u and 3 other fields | High correlation |
z is highly correlated with u and 3 other fields | High correlation |
run is highly correlated with objid | High correlation |
specobjid is highly correlated with plate and 1 other fields | High correlation |
plate is highly correlated with specobjid and 1 other fields | High correlation |
mjd is highly correlated with specobjid and 1 other fields | High correlation |
objid is highly correlated with run | High correlation |
u is highly correlated with g and 3 other fields | High correlation |
g is highly correlated with u and 3 other fields | High correlation |
r is highly correlated with u and 3 other fields | High correlation |
i is highly correlated with u and 3 other fields | High correlation |
z is highly correlated with u and 3 other fields | High correlation |
run is highly correlated with objid | High correlation |
specobjid is highly correlated with plate and 1 other fields | High correlation |
plate is highly correlated with specobjid and 1 other fields | High correlation |
mjd is highly correlated with specobjid and 1 other fields | High correlation |
objid is highly correlated with run | High correlation |
u is highly correlated with g | High correlation |
g is highly correlated with u and 3 other fields | High correlation |
r is highly correlated with g and 2 other fields | High correlation |
i is highly correlated with g and 2 other fields | High correlation |
z is highly correlated with g and 2 other fields | High correlation |
run is highly correlated with objid | High correlation |
specobjid is highly correlated with plate and 1 other fields | High correlation |
plate is highly correlated with specobjid and 1 other fields | High correlation |
mjd is highly correlated with specobjid and 1 other fields | High correlation |
rerun is highly correlated with class | High correlation |
class is highly correlated with rerun | High correlation |
objid is highly correlated with ra and 5 other fields | High correlation |
ra is highly correlated with objid and 3 other fields | High correlation |
dec is highly correlated with objid and 5 other fields | High correlation |
u is highly correlated with g and 3 other fields | High correlation |
g is highly correlated with u and 5 other fields | High correlation |
r is highly correlated with u and 5 other fields | High correlation |
i is highly correlated with u and 4 other fields | High correlation |
z is highly correlated with u and 4 other fields | High correlation |
run is highly correlated with objid and 5 other fields | High correlation |
field is highly correlated with ra | High correlation |
specobjid is highly correlated with objid and 5 other fields | High correlation |
class is highly correlated with g and 7 other fields | High correlation |
redshift is highly correlated with g and 2 other fields | High correlation |
plate is highly correlated with objid and 5 other fields | High correlation |
mjd is highly correlated with objid and 5 other fields | High correlation |
Reproduction
| Analysis started | 2022-06-27 16:02:32.799465 |
|---|---|
| Analysis finished | 2022-06-27 16:17:30.366459 |
| Duration | 14 minutes and 57.57 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 67951 |
|---|---|
| Distinct (%) | 65.0% |
| Missing | 471 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2376626 × 1018 |
| Minimum | 1.237645942 × 1018 |
|---|---|
| Maximum | 1.237680531 × 1018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 1.237645942 × 1018 |
|---|---|
| 5-th percentile | 1.237650763 × 1018 |
| Q1 | 1.237657613 × 1018 |
| median | 1.237662237 × 1018 |
| Q3 | 1.237667211 × 1018 |
| 95-th percentile | 1.2376786 × 1018 |
| Maximum | 1.237680531 × 1018 |
| Range | 3.458899502 × 1013 |
| Interquartile range (IQR) | 9.59764208 × 1012 |
Descriptive statistics
| Standard deviation | 7.297186796 × 1012 |
|---|---|
| Coefficient of variation (CV) | 5.895941911 × 10-6 |
| Kurtosis | -0.100111674 |
| Mean | 1.2376626 × 1018 |
| Median Absolute Deviation (MAD) | 4.62837783 × 1012 |
| Skewness | 0.2892833877 |
| Sum | 1.293716339 × 1023 |
| Variance | 5.324893513 × 1025 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.237657611 × 1018 | 22 | < 0.1% |
| 1.237665549 × 1018 | 18 | < 0.1% |
| 1.237659326 × 1018 | 18 | < 0.1% |
| 1.237666338 × 1018 | 17 | < 0.1% |
| 1.237661384 × 1018 | 17 | < 0.1% |
| 1.237656906 × 1018 | 17 | < 0.1% |
| 1.237659326 × 1018 | 16 | < 0.1% |
| 1.237666338 × 1018 | 16 | < 0.1% |
| 1.237648703 × 1018 | 15 | < 0.1% |
| 1.237655743 × 1018 | 13 | < 0.1% |
| Other values (67941) | 104360 | |
| (Missing) | 471 | 0.4% |
| Value | Count | Frequency (%) |
| 1.237645942 × 1018 | 1 | < 0.1% |
| 1.237645943 × 1018 | 1 | < 0.1% |
| 1.237645943 × 1018 | 1 | < 0.1% |
| 1.237645943 × 1018 | 2 | |
| 1.237645943 × 1018 | 1 | < 0.1% |
| 1.237645944 × 1018 | 2 | |
| 1.237645944 × 1018 | 1 | < 0.1% |
| 1.237645944 × 1018 | 1 | < 0.1% |
| 1.237645944 × 1018 | 1 | < 0.1% |
| 1.237645944 × 1018 | 3 |
| Value | Count | Frequency (%) |
| 1.237680531 × 1018 | 1 | < 0.1% |
| 1.237680531 × 1018 | 2 | |
| 1.237680531 × 1018 | 2 | |
| 1.237680531 × 1018 | 2 | |
| 1.237680531 × 1018 | 4 | |
| 1.23768053 × 1018 | 1 | < 0.1% |
| 1.23768053 × 1018 | 1 | < 0.1% |
| 1.23768053 × 1018 | 1 | < 0.1% |
| 1.23768053 × 1018 | 1 | < 0.1% |
| 1.23768053 × 1018 | 1 | < 0.1% |
| Distinct | 99998 |
|---|---|
| Distinct (%) | 95.7% |
| Missing | 503 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 177.3636281 |
| Minimum | 0.0130606182 |
|---|---|
| Maximum | 359.9996152 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 0.0130606182 |
|---|---|
| 5-th percentile | 19.29229108 |
| Q1 | 136.2073294 |
| median | 180.3154659 |
| Q3 | 224.3855998 |
| 95-th percentile | 331.8527005 |
| Maximum | 359.9996152 |
| Range | 359.9865546 |
| Interquartile range (IQR) | 88.17827047 |
Descriptive statistics
| Standard deviation | 78.32375233 |
|---|---|
| Coefficient of variation (CV) | 0.4415998542 |
| Kurtosis | 0.2894332768 |
| Mean | 177.3636281 |
| Median Absolute Deviation (MAD) | 44.08668798 |
| Skewness | -0.1478046655 |
| Sum | 18533967.05 |
| Variance | 6134.610179 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 135.7313013 | 6 | < 0.1% |
| 0.3848705536 | 5 | < 0.1% |
| 310.5235637 | 5 | < 0.1% |
| 181.2881219 | 5 | < 0.1% |
| 240.2767225 | 5 | < 0.1% |
| 169.6261759 | 5 | < 0.1% |
| 132.7264225 | 5 | < 0.1% |
| 3.491397341 | 5 | < 0.1% |
| 355.7171984 | 4 | < 0.1% |
| 329.954208 | 4 | < 0.1% |
| Other values (99988) | 104448 | |
| (Missing) | 503 | 0.5% |
| Value | Count | Frequency (%) |
| 0.0130606182 | 1 | |
| 0.013890033 | 1 | |
| 0.0151766885 | 1 | |
| 0.01639243 | 1 | |
| 0.0193603276 | 1 | |
| 0.029838174 | 1 | |
| 0.0302214478 | 1 | |
| 0.0314677494 | 1 | |
| 0.03805438 | 1 | |
| 0.0392718417 | 1 |
| Value | Count | Frequency (%) |
| 359.9996152 | 1 | < 0.1% |
| 359.9818523 | 1 | < 0.1% |
| 359.9739335 | 1 | < 0.1% |
| 359.9730615 | 1 | < 0.1% |
| 359.972675 | 3 | |
| 359.9644062 | 1 | < 0.1% |
| 359.961213 | 1 | < 0.1% |
| 359.9537366 | 1 | < 0.1% |
| 359.9489687 | 1 | < 0.1% |
| 359.9481466 | 1 | < 0.1% |
| Distinct | 99998 |
|---|---|
| Distinct (%) | 95.7% |
| Missing | 514 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.07701865 |
| Minimum | -19.49545595 |
|---|---|
| Maximum | 84.49049355 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 12314 |
| Negative (%) | 11.7% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | -19.49545595 |
|---|---|
| 5-th percentile | -2.564156087 |
| Q1 | 6.796899074 |
| median | 23.97616554 |
| Q3 | 40.35628529 |
| 95-th percentile | 59.54625483 |
| Maximum | 84.49049355 |
| Range | 103.9859495 |
| Interquartile range (IQR) | 33.55938621 |
Descriptive statistics
| Standard deviation | 20.54955798 |
|---|---|
| Coefficient of variation (CV) | 0.8194577777 |
| Kurtosis | -0.9006547811 |
| Mean | 25.07701865 |
| Median Absolute Deviation (MAD) | 16.77616393 |
| Skewness | 0.2645675607 |
| Sum | 2620197.371 |
| Variance | 422.284333 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22.42204467 | 6 | < 0.1% |
| 40.43167904 | 5 | < 0.1% |
| 7.134754626 | 5 | < 0.1% |
| 4.676497556 | 5 | < 0.1% |
| 21.22672474 | 5 | < 0.1% |
| 27.29241845 | 5 | < 0.1% |
| 17.46669494 | 5 | < 0.1% |
| 32.90371006 | 4 | < 0.1% |
| 44.8582933 | 4 | < 0.1% |
| 3.881093899 | 4 | < 0.1% |
| Other values (99988) | 104438 | |
| (Missing) | 514 | 0.5% |
| Value | Count | Frequency (%) |
| -19.49545595 | 1 | |
| -19.36457646 | 1 | |
| -19.29477092 | 1 | |
| -19.25250863 | 1 | |
| -19.05256932 | 1 | |
| -19.04569538 | 1 | |
| -19.00869862 | 1 | |
| -18.9640579 | 1 | |
| -18.9048726 | 1 | |
| -18.86596069 | 1 |
| Value | Count | Frequency (%) |
| 84.49049355 | 1 | |
| 84.41565961 | 1 | |
| 84.39379134 | 1 | |
| 84.37506776 | 1 | |
| 84.35513366 | 1 | |
| 84.34370967 | 1 | |
| 84.33491061 | 1 | |
| 84.33347541 | 1 | |
| 84.31706748 | 1 | |
| 84.31706407 | 1 |
| Distinct | 79840 |
|---|---|
| Distinct (%) | 76.4% |
| Missing | 453 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.64612461 |
| Minimum | 10.61181 |
|---|---|
| Maximum | 19.59995 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 10.61181 |
|---|---|
| 5-th percentile | 16.994123 |
| Q1 | 18.226545 |
| median | 18.88153 |
| Q3 | 19.2784 |
| 95-th percentile | 19.536647 |
| Maximum | 19.59995 |
| Range | 8.98814 |
| Interquartile range (IQR) | 1.051855 |
Descriptive statistics
| Standard deviation | 0.8286945168 |
|---|---|
| Coefficient of variation (CV) | 0.04444325748 |
| Kurtosis | 2.614982487 |
| Mean | 18.64612461 |
| Median Absolute Deviation (MAD) | 0.46885 |
| Skewness | -1.410525129 |
| Sum | 1949396.389 |
| Variance | 0.6867346022 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 19.28232 | 8 | < 0.1% |
| 19.50051 | 7 | < 0.1% |
| 18.5609 | 7 | < 0.1% |
| 19.5632 | 7 | < 0.1% |
| 19.06528 | 7 | < 0.1% |
| 18.935 | 7 | < 0.1% |
| 18.97973 | 7 | < 0.1% |
| 19.29348 | 7 | < 0.1% |
| 19.17588 | 7 | < 0.1% |
| 19.46334 | 7 | < 0.1% |
| Other values (79830) | 104476 | |
| (Missing) | 453 | 0.4% |
| Value | Count | Frequency (%) |
| 10.61181 | 1 | |
| 10.99623 | 1 | |
| 11.49125 | 1 | |
| 11.50794 | 1 | |
| 11.71639 | 1 | |
| 11.84577 | 1 | |
| 11.96091 | 1 | |
| 12.05521 | 1 | |
| 12.10168 | 1 | |
| 12.10933 | 1 |
| Value | Count | Frequency (%) |
| 19.59995 | 1 | < 0.1% |
| 19.59994 | 1 | < 0.1% |
| 19.59993 | 1 | < 0.1% |
| 19.59992 | 3 | |
| 19.5999 | 1 | < 0.1% |
| 19.59989 | 2 | |
| 19.59987 | 2 | |
| 19.59983 | 1 | < 0.1% |
| 19.59982 | 1 | < 0.1% |
| 19.59981 | 2 |
| Distinct | 85895 |
|---|---|
| Distinct (%) | 82.2% |
| Missing | 498 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.44646107 |
| Minimum | 9.668339 |
|---|---|
| Maximum | 19.99605 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 9.668339 |
|---|---|
| 5-th percentile | 15.6636305 |
| Q1 | 16.876755 |
| median | 17.543095 |
| Q3 | 18.09984 |
| 95-th percentile | 19.0453195 |
| Maximum | 19.99605 |
| Range | 10.327711 |
| Interquartile range (IQR) | 1.223085 |
Descriptive statistics
| Standard deviation | 1.003252479 |
|---|---|
| Coefficient of variation (CV) | 0.05750464093 |
| Kurtosis | 1.647466801 |
| Mean | 17.44646107 |
| Median Absolute Deviation (MAD) | 0.599615 |
| Skewness | -0.7048097714 |
| Sum | 1823190.075 |
| Variance | 1.006515537 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18.00261 | 7 | < 0.1% |
| 19.36184 | 6 | < 0.1% |
| 17.70518 | 6 | < 0.1% |
| 17.62819 | 6 | < 0.1% |
| 18.33341 | 6 | < 0.1% |
| 18.61752 | 6 | < 0.1% |
| 18.06462 | 6 | < 0.1% |
| 18.78448 | 6 | < 0.1% |
| 17.82619 | 5 | < 0.1% |
| 19.15025 | 5 | < 0.1% |
| Other values (85885) | 104443 | |
| (Missing) | 498 | 0.5% |
| Value | Count | Frequency (%) |
| 9.668339 | 1 | |
| 9.988 | 1 | |
| 9.989008 | 1 | |
| 10.0348 | 1 | |
| 10.0985 | 1 | |
| 10.39004 | 1 | |
| 10.4982 | 1 | |
| 10.51139 | 1 | |
| 10.5311 | 1 | |
| 10.53353 | 1 |
| Value | Count | Frequency (%) |
| 19.99605 | 1 | |
| 19.9842 | 1 | |
| 19.97499 | 1 | |
| 19.9073 | 1 | |
| 19.90642 | 1 | |
| 19.89474 | 1 | |
| 19.87725 | 1 | |
| 19.86832 | 1 | |
| 19.86373 | 1 | |
| 19.86168 | 1 |
| Distinct | 87969 |
|---|---|
| Distinct (%) | 84.2% |
| Missing | 536 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.93342247 |
| Minimum | 9.005167 |
|---|---|
| Maximum | 31.9901 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 9.005167 |
|---|---|
| 5-th percentile | 15.060213 |
| Q1 | 16.220455 |
| median | 16.93446 |
| Q3 | 17.648455 |
| 95-th percentile | 18.928511 |
| Maximum | 31.9901 |
| Range | 22.984933 |
| Interquartile range (IQR) | 1.428 |
Descriptive statistics
| Standard deviation | 1.158454844 |
|---|---|
| Coefficient of variation (CV) | 0.0684123275 |
| Kurtosis | 2.035794 |
| Mean | 16.93342247 |
| Median Absolute Deviation (MAD) | 0.714005 |
| Skewness | -0.1402745977 |
| Sum | 1768933.045 |
| Variance | 1.342017625 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17.36591 | 6 | < 0.1% |
| 19.23513 | 6 | < 0.1% |
| 18.18169 | 6 | < 0.1% |
| 18.79991 | 6 | < 0.1% |
| 18.88791 | 5 | < 0.1% |
| 17.18694 | 5 | < 0.1% |
| 17.41842 | 5 | < 0.1% |
| 17.03412 | 5 | < 0.1% |
| 18.33845 | 5 | < 0.1% |
| 18.48827 | 5 | < 0.1% |
| Other values (87959) | 104410 | |
| (Missing) | 536 | 0.5% |
| Value | Count | Frequency (%) |
| 9.005167 | 1 | |
| 9.050494 | 1 | |
| 9.167526 | 1 | |
| 9.356278 | 1 | |
| 9.533339 | 1 | |
| 9.564629 | 1 | |
| 9.603218 | 1 | |
| 9.685797 | 1 | |
| 9.690582 | 1 | |
| 9.73144 | 1 |
| Value | Count | Frequency (%) |
| 31.9901 | 1 | |
| 29.57186 | 1 | |
| 28.9422 | 1 | |
| 28.20384 | 1 | |
| 27.06385 | 1 | |
| 26.79265 | 1 | |
| 26.59133 | 1 | |
| 26.30579 | 1 | |
| 25.49612 | 1 | |
| 24.9727 | 1 |
| Distinct | 88623 |
|---|---|
| Distinct (%) | 84.8% |
| Missing | 506 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.68246364 |
| Minimum | 8.848403 |
|---|---|
| Maximum | 32.14147 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 8.848403 |
|---|---|
| 5-th percentile | 14.751799 |
| Q1 | 15.889685 |
| median | 16.64607 |
| Q3 | 17.41619 |
| 95-th percentile | 18.8476525 |
| Maximum | 32.14147 |
| Range | 23.293067 |
| Interquartile range (IQR) | 1.526505 |
Descriptive statistics
| Standard deviation | 1.23673037 |
|---|---|
| Coefficient of variation (CV) | 0.07413355708 |
| Kurtosis | 1.777398393 |
| Mean | 16.68246364 |
| Median Absolute Deviation (MAD) | 0.76327 |
| Skewness | 0.03995694952 |
| Sum | 1743217.355 |
| Variance | 1.529502008 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 19.24153 | 6 | < 0.1% |
| 19.02179 | 6 | < 0.1% |
| 17.37613 | 6 | < 0.1% |
| 18.77454 | 6 | < 0.1% |
| 18.13322 | 6 | < 0.1% |
| 18.57672 | 5 | < 0.1% |
| 15.99426 | 5 | < 0.1% |
| 18.1792 | 5 | < 0.1% |
| 18.7631 | 5 | < 0.1% |
| 18.99187 | 5 | < 0.1% |
| Other values (88613) | 104439 | |
| (Missing) | 506 | 0.5% |
| Value | Count | Frequency (%) |
| 8.848403 | 1 | |
| 8.896696 | 1 | |
| 8.917489 | 1 | |
| 9.082433 | 1 | |
| 9.10011 | 1 | |
| 9.321235 | 1 | |
| 9.400904 | 1 | |
| 9.406895 | 1 | |
| 9.456314 | 1 | |
| 9.46208 | 1 |
| Value | Count | Frequency (%) |
| 32.14147 | 1 | |
| 32.10178 | 1 | |
| 30.16359 | 1 | |
| 27.47143 | 1 | |
| 26.9687 | 1 | |
| 26.89399 | 1 | |
| 26.49636 | 1 | |
| 26.0441 | 1 | |
| 25.15362 | 1 | |
| 24.87711 | 1 |
| Distinct | 89451 |
|---|---|
| Distinct (%) | 85.6% |
| Missing | 518 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.52722576 |
| Minimum | 8.947795 |
|---|---|
| Maximum | 29.38374 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 8.947795 |
|---|---|
| 5-th percentile | 14.505378 |
| Q1 | 15.6484 |
| median | 16.479285 |
| Q3 | 17.3203725 |
| 95-th percentile | 18.82262 |
| Maximum | 29.38374 |
| Range | 20.435945 |
| Interquartile range (IQR) | 1.6719725 |
Descriptive statistics
| Standard deviation | 1.308750962 |
|---|---|
| Coefficient of variation (CV) | 0.07918757695 |
| Kurtosis | 0.8258176243 |
| Mean | 16.52722576 |
| Median Absolute Deviation (MAD) | 0.835415 |
| Skewness | 0.1071717878 |
| Sum | 1726797.602 |
| Variance | 1.71282908 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17.26416 | 6 | < 0.1% |
| 18.61593 | 6 | < 0.1% |
| 19.05516 | 5 | < 0.1% |
| 16.36791 | 5 | < 0.1% |
| 19.0807 | 5 | < 0.1% |
| 19.08307 | 5 | < 0.1% |
| 18.38336 | 5 | < 0.1% |
| 15.65332 | 5 | < 0.1% |
| 18.6076 | 5 | < 0.1% |
| 15.51277 | 5 | < 0.1% |
| Other values (89441) | 104430 | |
| (Missing) | 518 | 0.5% |
| Value | Count | Frequency (%) |
| 8.947795 | 1 | |
| 9.114825 | 1 | |
| 9.228836 | 1 | |
| 9.537069 | 1 | |
| 9.612333 | 1 | |
| 9.741912 | 1 | |
| 9.778091 | 1 | |
| 9.836641 | 1 | |
| 9.893856 | 1 | |
| 9.918173 | 1 |
| Value | Count | Frequency (%) |
| 29.38374 | 1 | |
| 28.79055 | 1 | |
| 28.02649 | 1 | |
| 27.67336 | 1 | |
| 26.51354 | 1 | |
| 26.04661 | 1 | |
| 25.33364 | 1 | |
| 24.70431 | 1 | |
| 24.68215 | 1 | |
| 24.56498 | 1 |
| Distinct | 516 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 508 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3987.288836 |
| Minimum | 109 |
|---|---|
| Maximum | 8162 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 109 |
|---|---|
| 5-th percentile | 1231 |
| Q1 | 2826 |
| median | 3903 |
| Q3 | 5061 |
| 95-th percentile | 7713 |
| Maximum | 8162 |
| Range | 8053 |
| Interquartile range (IQR) | 2235 |
Descriptive statistics
| Standard deviation | 1698.666908 |
|---|---|
| Coefficient of variation (CV) | 0.4260205313 |
| Kurtosis | -0.09943297995 |
| Mean | 3987.288836 |
| Median Absolute Deviation (MAD) | 1078 |
| Skewness | 0.2897279982 |
| Sum | 416639785 |
| Variance | 2885469.265 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2243 | 3116 | 3.0% |
| 3893 | 2422 | 2.3% |
| 3704 | 2221 | 2.1% |
| 2986 | 2166 | 2.1% |
| 752 | 2112 | 2.0% |
| 5972 | 2103 | 2.0% |
| 4674 | 1850 | 1.8% |
| 4576 | 1618 | 1.5% |
| 4294 | 1575 | 1.5% |
| 3705 | 1536 | 1.5% |
| Other values (506) | 83773 |
| Value | Count | Frequency (%) |
| 109 | 16 | < 0.1% |
| 211 | 43 | < 0.1% |
| 259 | 3 | < 0.1% |
| 287 | 2 | < 0.1% |
| 307 | 86 | 0.1% |
| 308 | 48 | < 0.1% |
| 745 | 113 | 0.1% |
| 752 | 2112 | |
| 756 | 874 | |
| 994 | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 8162 | 28 | < 0.1% |
| 8158 | 2 | < 0.1% |
| 8157 | 11 | < 0.1% |
| 8156 | 32 | |
| 8155 | 13 | < 0.1% |
| 8151 | 14 | < 0.1% |
| 8150 | 5 | < 0.1% |
| 8149 | 2 | < 0.1% |
| 8142 | 1 | < 0.1% |
| 8116 | 70 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 539 |
| Missing (%) | 0.5% |
| Memory size | 820.4 KiB |
| 301.0 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 522305 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 301.0 |
|---|---|
| 2nd row | 301.0 |
| 3rd row | 301.0 |
| 4th row | 301.0 |
| 5th row | 301.0 |
Common Values
| Value | Count | Frequency (%) |
| 301.0 | 104461 | |
| (Missing) | 539 | 0.5% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 301.0 | 104461 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 208922 | |
| 3 | 104461 | |
| 1 | 104461 | |
| . | 104461 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 417844 | |
| Other Punctuation | 104461 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 208922 | |
| 3 | 104461 | |
| 1 | 104461 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 104461 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 522305 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 208922 | |
| 3 | 104461 | |
| 1 | 104461 | |
| . | 104461 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 522305 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 208922 | |
| 3 | 104461 | |
| 1 | 104461 | |
| . | 104461 |
camcol
Real number (ℝ≥0)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 496 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.274353135 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.620960607 |
|---|---|
| Coefficient of variation (CV) | 0.4950475835 |
| Kurtosis | -1.141387787 |
| Mean | 3.274353135 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.1268195353 |
| Sum | 342183 |
| Variance | 2.627513289 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 19393 | |
| 3 | 19318 | |
| 1 | 19149 | |
| 2 | 19037 | |
| 5 | 16208 | |
| 6 | 11399 | |
| (Missing) | 496 | 0.5% |
| Value | Count | Frequency (%) |
| 1 | 19149 | |
| 2 | 19037 | |
| 3 | 19318 | |
| 4 | 19393 | |
| 5 | 16208 | |
| 6 | 11399 |
| Value | Count | Frequency (%) |
| 6 | 11399 | |
| 5 | 16208 | |
| 4 | 19393 | |
| 3 | 19318 | |
| 2 | 19037 | |
| 1 | 19149 |
| Distinct | 840 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 476 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 187.085808 |
| Minimum | 11 |
|---|---|
| Maximum | 982 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 31 |
| Q1 | 85 |
| median | 153 |
| Q3 | 249 |
| 95-th percentile | 476 |
| Maximum | 982 |
| Range | 971 |
| Interquartile range (IQR) | 164 |
Descriptive statistics
| Standard deviation | 140.884349 |
|---|---|
| Coefficient of variation (CV) | 0.7530466927 |
| Kurtosis | 2.616465326 |
| Mean | 187.085808 |
| Median Absolute Deviation (MAD) | 77 |
| Skewness | 1.494813155 |
| Sum | 19554957 |
| Variance | 19848.39979 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 98 | 463 | 0.4% |
| 61 | 462 | 0.4% |
| 99 | 455 | 0.4% |
| 65 | 450 | 0.4% |
| 67 | 448 | 0.4% |
| 63 | 445 | 0.4% |
| 97 | 444 | 0.4% |
| 66 | 439 | 0.4% |
| 56 | 438 | 0.4% |
| 131 | 432 | 0.4% |
| Other values (830) | 100048 | |
| (Missing) | 476 | 0.5% |
| Value | Count | Frequency (%) |
| 11 | 215 | |
| 12 | 188 | |
| 13 | 227 | |
| 14 | 211 | |
| 15 | 192 | |
| 16 | 209 | |
| 17 | 222 | |
| 18 | 241 | |
| 19 | 221 | |
| 20 | 248 |
| Value | Count | Frequency (%) |
| 982 | 1 | |
| 977 | 1 | |
| 974 | 1 | |
| 972 | 1 | |
| 971 | 1 | |
| 970 | 1 | |
| 860 | 1 | |
| 848 | 1 | |
| 846 | 1 | |
| 845 | 2 |
| Distinct | 100000 |
|---|---|
| Distinct (%) | 95.7% |
| Missing | 498 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.968231684 × 1018 |
| Minimum | 2.994896774 × 1017 |
|---|---|
| Maximum | 1.317645238 × 1019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 2.994896774 × 1017 |
|---|---|
| 5-th percentile | 4.469861826 × 1017 |
| Q1 | 1.339866632 × 1018 |
| median | 2.367807557 × 1018 |
| Q3 | 3.30910642 × 1018 |
| 95-th percentile | 8.715861478 × 1018 |
| Maximum | 1.317645238 × 1019 |
| Range | 1.287696271 × 1019 |
| Interquartile range (IQR) | 1.969239787 × 1018 |
Descriptive statistics
| Standard deviation | 2.552331925 × 1018 |
|---|---|
| Coefficient of variation (CV) | 0.8598829863 |
| Kurtosis | 2.949536078 |
| Mean | 2.968231684 × 1018 |
| Median Absolute Deviation (MAD) | 9.796265337 × 1017 |
| Skewness | 1.793483855 |
| Sum | 3.101861474 × 1023 |
| Variance | 6.514398253 × 1036 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.446692163 × 1018 | 6 | < 0.1% |
| 7.202432938 × 1018 | 6 | < 0.1% |
| 1.34212606 × 1018 | 6 | < 0.1% |
| 1.621351993 × 1018 | 5 | < 0.1% |
| 2.921850791 × 1018 | 5 | < 0.1% |
| 1.104539735 × 1018 | 5 | < 0.1% |
| 8.551262136 × 1018 | 5 | < 0.1% |
| 1.375940167 × 1018 | 4 | < 0.1% |
| 4.255045766 × 1018 | 4 | < 0.1% |
| 8.549063663 × 1018 | 4 | < 0.1% |
| Other values (99990) | 104452 | |
| (Missing) | 498 | 0.5% |
| Value | Count | Frequency (%) |
| 2.994896774 × 1017 | 1 | |
| 2.995190894 × 1017 | 1 | |
| 2.995278855 × 1017 | 1 | |
| 2.995669181 × 1017 | 2 | |
| 2.995935813 × 1017 | 1 | |
| 2.996007281 × 1017 | 1 | |
| 2.996048513 × 1017 | 1 | |
| 2.996169459 × 1017 | 1 | |
| 2.996177705 × 1017 | 1 | |
| 2.996375618 × 1017 | 1 |
| Value | Count | Frequency (%) |
| 1.317645238 × 1019 | 2 | |
| 1.314852314 × 1019 | 1 | |
| 1.314739421 × 1019 | 1 | |
| 1.314731203 × 1019 | 1 | |
| 1.314720015 × 1019 | 1 | |
| 1.314717266 × 1019 | 1 | |
| 1.314625265 × 1019 | 1 | |
| 1.314619217 × 1019 | 1 | |
| 1.314616001 × 1019 | 1 | |
| 1.314614324 × 1019 | 1 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 820.4 KiB |
| GALAXY | |
|---|---|
| STAR | |
| QSO |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.840619048 |
| Min length | 3 |
Characters and Unicode
| Total characters | 508265 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | STAR |
|---|---|
| 2nd row | GALAXY |
| 3rd row | GALAXY |
| 4th row | GALAXY |
| 5th row | QSO |
Common Values
| Value | Count | Frequency (%) |
| GALAXY | 51323 | |
| STAR | 39296 | |
| QSO | 14381 | 13.7% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| galaxy | 51323 | |
| star | 39296 | |
| qso | 14381 | 13.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 141942 | |
| S | 53677 | 10.6% |
| G | 51323 | 10.1% |
| L | 51323 | 10.1% |
| X | 51323 | 10.1% |
| Y | 51323 | 10.1% |
| T | 39296 | 7.7% |
| R | 39296 | 7.7% |
| Q | 14381 | 2.8% |
| O | 14381 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 508265 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 141942 | |
| S | 53677 | 10.6% |
| G | 51323 | 10.1% |
| L | 51323 | 10.1% |
| X | 51323 | 10.1% |
| Y | 51323 | 10.1% |
| T | 39296 | 7.7% |
| R | 39296 | 7.7% |
| Q | 14381 | 2.8% |
| O | 14381 | 2.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 508265 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 141942 | |
| S | 53677 | 10.6% |
| G | 51323 | 10.1% |
| L | 51323 | 10.1% |
| X | 51323 | 10.1% |
| Y | 51323 | 10.1% |
| T | 39296 | 7.7% |
| R | 39296 | 7.7% |
| Q | 14381 | 2.8% |
| O | 14381 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 508265 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 141942 | |
| S | 53677 | 10.6% |
| G | 51323 | 10.1% |
| L | 51323 | 10.1% |
| X | 51323 | 10.1% |
| Y | 51323 | 10.1% |
| T | 39296 | 7.7% |
| R | 39296 | 7.7% |
| Q | 14381 | 2.8% |
| O | 14381 | 2.8% |
| Distinct | 99298 |
|---|---|
| Distinct (%) | 95.0% |
| Missing | 517 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2024597147 |
| Minimum | -0.004136078 |
|---|---|
| Maximum | 7.011245 |
| Zeros | 401 |
| Zeros (%) | 0.4% |
| Negative | 25265 |
| Negative (%) | 24.1% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | -0.004136078 |
|---|---|
| 5-th percentile | -0.00050897616 |
| Q1 | 7.4106295 × 10-6 |
| median | 0.0483957 |
| Q3 | 0.101922 |
| 95-th percentile | 1.454975 |
| Maximum | 7.011245 |
| Range | 7.015381078 |
| Interquartile range (IQR) | 0.1019145894 |
Descriptive statistics
| Standard deviation | 0.4840987539 |
|---|---|
| Coefficient of variation (CV) | 2.391086813 |
| Kurtosis | 16.35971385 |
| Mean | 0.2024597147 |
| Median Absolute Deviation (MAD) | 0.04840843535 |
| Skewness | 3.552813238 |
| Sum | 21153.59837 |
| Variance | 0.2343516035 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 401 | 0.4% |
| 0.004153254 | 13 | < 0.1% |
| 0.0004606231 | 8 | < 0.1% |
| 1.30766 | 6 | < 0.1% |
| 0.5738784 | 6 | < 0.1% |
| 1.036473 | 6 | < 0.1% |
| 0.8240715 | 5 | < 0.1% |
| 0.4389864 | 5 | < 0.1% |
| 0.2354126 | 5 | < 0.1% |
| 0.1548114 | 5 | < 0.1% |
| Other values (99288) | 104023 | |
| (Missing) | 517 | 0.5% |
| Value | Count | Frequency (%) |
| -0.004136078 | 3 | |
| -0.004020656 | 1 | < 0.1% |
| -0.004020589 | 1 | < 0.1% |
| -0.004019734 | 1 | < 0.1% |
| -0.003955937 | 1 | < 0.1% |
| -0.00392177 | 1 | < 0.1% |
| -0.003808179 | 1 | < 0.1% |
| -0.003798116 | 1 | < 0.1% |
| -0.003789981 | 1 | < 0.1% |
| -0.003730139 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7.011245 | 1 | |
| 6.991177 | 2 | |
| 6.571713 | 1 | |
| 6.517635 | 1 | |
| 6.404233 | 1 | |
| 6.376496 | 1 | |
| 6.354554 | 1 | |
| 6.269251 | 1 | |
| 6.127684 | 1 | |
| 5.908446 | 1 |
| Distinct | 6117 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 510 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2636.85456 |
| Minimum | 266 |
|---|---|
| Maximum | 11703 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 266 |
|---|---|
| 5-th percentile | 397 |
| Q1 | 1190 |
| median | 2103 |
| Q3 | 2939 |
| 95-th percentile | 7749 |
| Maximum | 11703 |
| Range | 11437 |
| Interquartile range (IQR) | 1749 |
Descriptive statistics
| Standard deviation | 2268.470352 |
|---|---|
| Coefficient of variation (CV) | 0.8602940739 |
| Kurtosis | 2.95245923 |
| Mean | 2636.85456 |
| Median Absolute Deviation (MAD) | 870 |
| Skewness | 1.794538261 |
| Sum | 275524933 |
| Variance | 5145957.737 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2939 | 238 | 0.2% |
| 2337 | 216 | 0.2% |
| 2299 | 204 | 0.2% |
| 2888 | 202 | 0.2% |
| 2394 | 197 | 0.2% |
| 1596 | 173 | 0.2% |
| 2310 | 169 | 0.2% |
| 2384 | 161 | 0.2% |
| 1433 | 161 | 0.2% |
| 2667 | 161 | 0.2% |
| Other values (6107) | 102608 | |
| (Missing) | 510 | 0.5% |
| Value | Count | Frequency (%) |
| 266 | 17 | |
| 267 | 22 | |
| 268 | 18 | |
| 269 | 13 | |
| 270 | 22 | |
| 271 | 18 | |
| 272 | 11 | |
| 273 | 16 | |
| 274 | 9 | |
| 275 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 11703 | 2 | < 0.1% |
| 11678 | 1 | < 0.1% |
| 11677 | 4 | |
| 11676 | 8 | |
| 11654 | 9 | |
| 11653 | 4 | |
| 11651 | 6 | |
| 11650 | 4 | |
| 11649 | 1 | < 0.1% |
| 11636 | 3 | < 0.1% |
| Distinct | 2167 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 503 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53943.28491 |
| Minimum | 51608 |
|---|---|
| Maximum | 58543 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 51608 |
|---|---|
| 5-th percentile | 51957 |
| Q1 | 52734 |
| median | 53734 |
| Q3 | 54613 |
| 95-th percentile | 57357 |
| Maximum | 58543 |
| Range | 6935 |
| Interquartile range (IQR) | 1879 |
Descriptive statistics
| Standard deviation | 1575.078088 |
|---|---|
| Coefficient of variation (CV) | 0.02919877963 |
| Kurtosis | 0.4103413998 |
| Mean | 53943.28491 |
| Median Absolute Deviation (MAD) | 972 |
| Skewness | 0.9230120903 |
| Sum | 5636911443 |
| Variance | 2480870.984 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 52411 | 431 | 0.4% |
| 53084 | 426 | 0.4% |
| 53770 | 382 | 0.4% |
| 53050 | 360 | 0.3% |
| 52781 | 347 | 0.3% |
| 52378 | 335 | 0.3% |
| 52765 | 329 | 0.3% |
| 53762 | 326 | 0.3% |
| 54169 | 321 | 0.3% |
| 52641 | 319 | 0.3% |
| Other values (2157) | 100921 | |
| (Missing) | 503 | 0.5% |
| Value | Count | Frequency (%) |
| 51608 | 22 | < 0.1% |
| 51609 | 101 | |
| 51612 | 17 | < 0.1% |
| 51613 | 59 | |
| 51614 | 12 | < 0.1% |
| 51615 | 70 | |
| 51630 | 17 | < 0.1% |
| 51633 | 18 | < 0.1% |
| 51637 | 48 | |
| 51658 | 21 | < 0.1% |
| Value | Count | Frequency (%) |
| 58543 | 14 | |
| 58526 | 13 | |
| 58523 | 8 | < 0.1% |
| 58522 | 7 | < 0.1% |
| 58515 | 20 | |
| 58514 | 12 | |
| 58512 | 14 | |
| 58511 | 11 | < 0.1% |
| 58510 | 29 | |
| 58509 | 1 | < 0.1% |
fiberid
Real number (ℝ≥0)
| Distinct | 1000 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 517 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 343.3096293 |
| Minimum | 1 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 820.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 161 |
| median | 328 |
| Q3 | 504 |
| 95-th percentile | 709 |
| Maximum | 1000 |
| Range | 999 |
| Interquartile range (IQR) | 343 |
Descriptive statistics
| Standard deviation | 218.4626466 |
|---|---|
| Coefficient of variation (CV) | 0.6363429044 |
| Kurtosis | -0.2271837203 |
| Mean | 343.3096293 |
| Median Absolute Deviation (MAD) | 172 |
| Skewness | 0.4810569027 |
| Sum | 35870020 |
| Variance | 47725.92797 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46 | 216 | 0.2% |
| 250 | 209 | 0.2% |
| 90 | 208 | 0.2% |
| 210 | 207 | 0.2% |
| 48 | 207 | 0.2% |
| 44 | 205 | 0.2% |
| 134 | 203 | 0.2% |
| 52 | 199 | 0.2% |
| 529 | 194 | 0.2% |
| 124 | 193 | 0.2% |
| Other values (990) | 102442 | |
| (Missing) | 517 | 0.5% |
| Value | Count | Frequency (%) |
| 1 | 150 | |
| 2 | 174 | |
| 3 | 151 | |
| 4 | 182 | |
| 5 | 160 | |
| 6 | 179 | |
| 7 | 174 | |
| 8 | 183 | |
| 9 | 188 | |
| 10 | 190 |
| Value | Count | Frequency (%) |
| 1000 | 30 | |
| 999 | 8 | < 0.1% |
| 998 | 18 | |
| 997 | 20 | |
| 996 | 26 | |
| 995 | 9 | < 0.1% |
| 994 | 29 | |
| 993 | 9 | < 0.1% |
| 992 | 30 | |
| 991 | 12 | < 0.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| objid | ra | dec | u | g | r | i | z | run | rerun | camcol | field | specobjid | class | redshift | plate | mjd | fiberid | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.237658e+18 | 122.472536 | 29.477546 | 18.80104 | 18.79409 | 19.17904 | 19.46893 | 19.62121 | 2830.0 | 301.0 | 1.0 | 82.0 | 5.011614e+18 | STAR | 0.000113 | 4451.0 | 55537.0 | 848.0 |
| 1 | 1.237661e+18 | 157.220491 | 38.044462 | 19.21634 | 17.36450 | 16.39222 | 15.96160 | 15.62490 | 3647.0 | 301.0 | 1.0 | 123.0 | 1.607801e+18 | GALAXY | 0.107083 | 1428.0 | 52998.0 | 56.0 |
| 2 | 1.237665e+18 | 128.426499 | 22.244187 | 17.58285 | 16.66683 | 16.37511 | 16.23573 | 16.03283 | 4517.0 | 301.0 | 2.0 | 113.0 | 2.171901e+18 | GALAXY | 0.024777 | 1929.0 | 53349.0 | 144.0 |
| 3 | 1.237655e+18 | 148.311910 | 3.603649 | 19.49339 | 18.02611 | 17.21924 | 16.73868 | 16.43414 | 2125.0 | 301.0 | 3.0 | 197.0 | 6.429279e+17 | GALAXY | 0.091564 | 571.0 | 52286.0 | 142.0 |
| 4 | 1.237649e+18 | 188.615906 | 0.966501 | 19.11787 | 18.80892 | 18.65386 | 18.43037 | 18.44886 | 752.0 | 301.0 | 6.0 | 301.0 | 3.266113e+17 | QSO | 1.528742 | 290.0 | 51941.0 | 365.0 |
| 5 | 1.237651e+18 | 172.252999 | -3.638291 | 19.11441 | 18.79149 | 18.63161 | 18.70045 | 18.59555 | 1231.0 | 301.0 | 1.0 | 20.0 | 3.670583e+17 | QSO | 0.864346 | 326.0 | 52375.0 | 54.0 |
| 6 | 1.237671e+18 | 191.230726 | -3.112741 | 19.41399 | 18.23463 | 17.74263 | 17.58676 | 17.50622 | 6005.0 | 301.0 | 4.0 | 143.0 | 3.289917e+18 | STAR | -0.000151 | 2922.0 | 54612.0 | 135.0 |
| 7 | 1.237649e+18 | 239.601256 | 0.692352 | 18.96478 | 17.75327 | 17.13841 | 16.75577 | 16.49653 | 745.0 | 301.0 | 5.0 | 540.0 | 3.863387e+17 | GALAXY | 0.101707 | 343.0 | 51692.0 | 564.0 |
| 8 | 1.237666e+18 | 210.129818 | 21.887381 | 18.97254 | 17.95227 | 17.55222 | 17.25796 | 17.23362 | 4678.0 | 301.0 | 1.0 | 62.0 | 3.118898e+18 | GALAXY | 0.066814 | 2770.0 | 54510.0 | 565.0 |
| 9 | 1.237665e+18 | 215.327913 | 34.261157 | 18.54177 | 17.20249 | 16.58703 | 16.15198 | 15.96899 | 4512.0 | 301.0 | 5.0 | 112.0 | 2.071777e+18 | GALAXY | 0.068231 | 1840.0 | 53472.0 | 442.0 |
Last rows
| objid | ra | dec | u | g | r | i | z | run | rerun | camcol | field | specobjid | class | redshift | plate | mjd | fiberid | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104990 | 1.237662e+18 | 224.011895 | 36.243035 | 18.44631 | 16.82548 | 16.07565 | 15.67125 | 15.41776 | 3893.0 | 301.0 | 5.0 | 379.0 | 1.558349e+18 | GALAXY | 0.047248 | 1384.0 | 53121.0 | 378.0 |
| 104991 | 1.237672e+18 | 259.927162 | 34.800604 | 18.32557 | 16.80251 | 16.02179 | 15.62505 | 15.33217 | 6161.0 | 301.0 | 6.0 | 102.0 | 5.622990e+18 | GALAXY | 0.083648 | 4994.0 | 55739.0 | 894.0 |
| 104992 | 1.237661e+18 | 139.313650 | 31.772846 | 17.45713 | 16.32932 | 15.96161 | 15.76178 | 15.83675 | 3704.0 | 301.0 | 2.0 | 52.0 | 2.680879e+18 | STAR | 0.000030 | 2381.0 | 53762.0 | 403.0 |
| 104993 | 1.237661e+18 | 140.914231 | 36.972574 | 17.34234 | 16.23905 | 16.17270 | 16.18831 | 16.22020 | 3606.0 | 301.0 | 6.0 | 119.0 | 1.434510e+18 | STAR | -0.000061 | 1274.0 | 52995.0 | 413.0 |
| 104994 | 1.237671e+18 | 72.490907 | 21.889203 | 18.68200 | 17.35598 | 16.78037 | 16.53070 | 16.39374 | 6003.0 | 301.0 | 2.0 | 201.0 | 3.038955e+18 | STAR | 0.000052 | 2699.0 | 54414.0 | 549.0 |
| 104995 | 1.237666e+18 | 53.104646 | 0.406206 | 19.56170 | 18.10295 | 17.53076 | 17.22465 | 17.07487 | 4849.0 | 301.0 | 4.0 | 809.0 | 4.673661e+17 | GALAXY | 0.022364 | 415.0 | 51810.0 | 428.0 |
| 104996 | 1.237667e+18 | 139.371132 | 21.871209 | 19.20145 | 17.67397 | 17.09594 | 16.88945 | 16.81790 | 5071.0 | 301.0 | 3.0 | 169.0 | 2.594136e+18 | STAR | 0.000077 | 2304.0 | 53762.0 | 227.0 |
| 104997 | 1.237658e+18 | 195.616433 | 50.155119 | 17.31194 | 16.21064 | 15.83690 | 15.70822 | 15.67614 | 2964.0 | 301.0 | 5.0 | 367.0 | 3.646903e+18 | STAR | -0.000121 | 3239.0 | 54888.0 | 410.0 |
| 104998 | 1.237662e+18 | 185.585052 | 6.434501 | 18.73713 | 17.59770 | 17.01564 | 16.67914 | 16.42806 | 3841.0 | 301.0 | 1.0 | 138.0 | 1.830781e+18 | GALAXY | 0.074901 | 1626.0 | 53472.0 | 248.0 |
| 104999 | 1.237652e+18 | 153.672995 | 64.455561 | 19.11557 | 18.84617 | 18.69063 | 18.48210 | 18.46087 | 1412.0 | 301.0 | 4.0 | 82.0 | 5.495722e+17 | QSO | 1.536277 | 488.0 | 51914.0 | 484.0 |
Most frequently occurring
| objid | ra | dec | u | g | r | i | z | run | rerun | camcol | field | specobjid | class | redshift | plate | mjd | fiberid | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21 | 1.237650e+18 | 60.006771 | -5.453765 | 18.53520 | 18.49669 | 18.12900 | 18.08370 | 18.07291 | 1045.0 | 301.0 | 4.0 | 173.0 | 5.225630e+17 | QSO | 1.381268 | 464.0 | 51908.0 | 529.0 | 3 |
| 94 | 1.237655e+18 | 148.865113 | 4.069995 | 19.21370 | 19.05957 | 18.95785 | 18.89791 | 18.96534 | 2125.0 | 301.0 | 4.0 | 201.0 | 6.430538e+17 | QSO | 1.436372 | 571.0 | 52286.0 | 600.0 | 3 |
| 103 | 1.237655e+18 | 200.831807 | 4.288257 | 19.39729 | 18.86379 | 18.69236 | 18.71441 | 18.55873 | 2190.0 | 301.0 | 2.0 | 126.0 | 5.360644e+18 | QSO | 2.325378 | 4761.0 | 55633.0 | 854.0 | 3 |
| 250 | 1.237659e+18 | 220.918335 | 55.258932 | 19.03294 | 18.97697 | 18.69969 | 18.61315 | 18.64826 | 3225.0 | 301.0 | 5.0 | 81.0 | 1.308459e+18 | QSO | 1.159161 | 1162.0 | 52668.0 | 594.0 | 3 |
| 253 | 1.237659e+18 | 259.377965 | 26.374453 | 18.91517 | 18.53948 | 18.44126 | 18.33421 | 18.10391 | 3225.0 | 301.0 | 5.0 | 349.0 | 5.632988e+18 | QSO | 2.202398 | 5003.0 | 55715.0 | 404.0 | 3 |
| 301 | 1.237661e+18 | 141.404255 | 33.260906 | 19.51994 | 19.38527 | 19.18023 | 19.32940 | 19.23339 | 3704.0 | 301.0 | 3.0 | 67.0 | 1.153174e+19 | QSO | 1.079241 | 10242.0 | 58161.0 | 980.0 | 3 |
| 393 | 1.237662e+18 | 215.824972 | 48.504365 | 19.04819 | 18.57168 | 18.48827 | 18.25663 | 18.12816 | 3918.0 | 301.0 | 4.0 | 139.0 | 9.495987e+18 | QSO | 0.568441 | 8434.0 | 57484.0 | 534.0 | 3 |
| 408 | 1.237662e+18 | 238.852274 | 34.659386 | 19.52406 | 19.25669 | 19.28052 | 19.08162 | 19.19201 | 3958.0 | 301.0 | 3.0 | 63.0 | 1.596615e+18 | QSO | 1.625367 | 1418.0 | 53142.0 | 324.0 | 3 |
| 412 | 1.237662e+18 | 245.379582 | 30.673344 | 19.50459 | 19.32491 | 19.33657 | 19.27321 | 19.52608 | 3958.0 | 301.0 | 4.0 | 109.0 | 1.229260e+19 | QSO | 1.402460 | 10918.0 | 58254.0 | 107.0 | 3 |
| 413 | 1.237662e+18 | 234.511749 | 38.360236 | 19.24319 | 19.02829 | 18.90838 | 18.90276 | 18.21580 | 3958.0 | 301.0 | 5.0 | 30.0 | 1.457072e+18 | QSO | 0.287838 | 1294.0 | 52753.0 | 574.0 | 3 |